﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_ZYCF')
            and   type = 'U')
   drop table GXBZ_EMR_ZYCF
go

/*==============================================================*/
/* Table: GXBZ_EMR_ZYCF                                         */
/*==============================================================*/
create table GXBZ_EMR_ZYCF (
   YZLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   MJZBSH               varchar(64)          null,
   CFBH                 varchar(64)          null,
   CFKLKSDM             varchar(64)          null,
   CFKLKSMC             varchar(32)          null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(64)          null,
   KFSJ                 datetime             null,
   KFSSGH               varchar(64)          null,
   KFYSXM               varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   SHYJSGH              varchar(64)          null,
   SHYJSXM              varchar(30)          null,
   TPYJSGH              varchar(64)          null,
   TPYJSXM              varchar(30)          null,
   HDYJSGH              varchar(64)          null,
   HDYJSXM              varchar(30)          null,
   FYYJSGH              varchar(64)          null,
   FYYJSXM              varchar(30)          null,
   XYZDDM               varchar(20)          null,
   XYZDMC               varchar(100)         null,
   ZYZDDM               varchar(20)          null,
   ZYZDMC               varchar(100)         null,
   ZYZHDM               varchar(20)          null,
   ZYZHMC               varchar(100)         null,
   YWSYTJDM             varchar(6)           null,
   YWSYTJMC             varchar(100)         null,
   YWYCSL               decimal(18,4)        null,
   YWSYPL               varchar(20)          null,
   YWJXDM               varchar(3)           null,
   YWJXMC               varchar(50)          null,
   YPDM                 varchar(20)          null,
   YPMC                 varchar(100)         null,
   YPGG                 varchar(128)         null,
   YWSYZSL              decimal(18,4)        null,
   CFTS                 decimal(3,0)         null,
   CFYPZH               varchar(32)          null,
   ZYYPCFMS             varchar(1024)        null,
   ZYYPJS               decimal(3,0)         null,
   ZYJZFFMS             varchar(1024)        null,
   YWSYFFMS             varchar(1024)        null,
   CFFLDM               varchar(30)          null,
   CFFLMC               varchar(64)          null,
   XMJE                 decimal(10,2)        null,
   BZ                   varchar(1024)        null,
   ZZZF                 char(100)            null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_ZYCF primary key (YZLSH, XGBZ)
)
go
